Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 561441 |
| Missing cells | 2799718 |
| Missing cells (%) | 16.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 132.8 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| Categorical | 5 |
| Text | 6 |
CANCELLED is highly imbalanced (87.5%) | Imbalance |
DIVERTED is highly imbalanced (97.2%) | Imbalance |
DEP_TIME has 9310 (1.7%) missing values | Missing |
DEP_DELAY has 9311 (1.7%) missing values | Missing |
TAXI_OUT has 9528 (1.7%) missing values | Missing |
TAXI_IN has 9769 (1.7%) missing values | Missing |
ARR_TIME has 9769 (1.7%) missing values | Missing |
ARR_DELAY has 11192 (2.0%) missing values | Missing |
CANCELLATION_CODE has 551852 (98.3%) missing values | Missing |
AIR_TIME has 11192 (2.0%) missing values | Missing |
CARRIER_DELAY has 435559 (77.6%) missing values | Missing |
WEATHER_DELAY has 435559 (77.6%) missing values | Missing |
NAS_DELAY has 435559 (77.6%) missing values | Missing |
SECURITY_DELAY has 435559 (77.6%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 435559 (77.6%) missing values | Missing |
WEATHER_DELAY is highly skewed (γ1 = 22.39920382) | Skewed |
SECURITY_DELAY is highly skewed (γ1 = 50.38334166) | Skewed |
DEP_DELAY has 25076 (4.5%) zeros | Zeros |
ARR_DELAY has 10477 (1.9%) zeros | Zeros |
CARRIER_DELAY has 54172 (9.6%) zeros | Zeros |
WEATHER_DELAY has 119465 (21.3%) zeros | Zeros |
NAS_DELAY has 64125 (11.4%) zeros | Zeros |
SECURITY_DELAY has 125147 (22.3%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 59767 (10.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 06:15:45.166729 |
|---|---|
| Analysis finished | 2024-03-30 06:20:12.391048 |
| Duration | 4 minutes and 27.22 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1335136 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0356145 |
|---|---|
| Coefficient of variation (CV) | 0.49246591 |
| Kurtosis | -1.2762366 |
| Mean | 4.1335136 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.083392513 |
| Sum | 2320724 |
| Variance | 4.1437265 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 7 | 94628 | |
| 6 | 84070 | |
| 5 | 78389 | |
| 4 | 78222 | |
| 1 | 78023 | |
| 3 | 74834 | |
| 2 | 73275 |
| Value | Count | Frequency (%) |
| 1 | 78023 | |
| 2 | 73275 | |
| 3 | 74834 | |
| 4 | 78222 | |
| 5 | 78389 | |
| 6 | 84070 | |
| 7 | 94628 |
| Value | Count | Frequency (%) |
| 7 | 94628 | |
| 6 | 84070 | |
| 5 | 78389 | |
| 4 | 78222 | |
| 3 | 74834 | |
| 2 | 73275 | |
| 1 | 78023 |
FL_DATE
Categorical
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 4/14/2023 12:00:00 AM | 19636 |
|---|---|
| 4/7/2023 12:00:00 AM | 19591 |
| 4/21/2023 12:00:00 AM | 19585 |
| 4/13/2023 12:00:00 AM | 19585 |
| 4/28/2023 12:00:00 AM | 19577 |
| Other values (25) |
Length
| Max length | 21 |
|---|---|
| Median length | 21 |
| Mean length | 20.702419 |
| Min length | 20 |
Characters and Unicode
| Total characters | 11623187 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4/3/2023 12:00:00 AM |
|---|---|
| 2nd row | 4/3/2023 12:00:00 AM |
| 3rd row | 4/3/2023 12:00:00 AM |
| 4th row | 4/3/2023 12:00:00 AM |
| 5th row | 4/3/2023 12:00:00 AM |
Common Values
| Value | Count | Frequency (%) |
| 4/14/2023 12:00:00 AM | 19636 | 3.5% |
| 4/7/2023 12:00:00 AM | 19591 | 3.5% |
| 4/21/2023 12:00:00 AM | 19585 | 3.5% |
| 4/13/2023 12:00:00 AM | 19585 | 3.5% |
| 4/28/2023 12:00:00 AM | 19577 | 3.5% |
| 4/6/2023 12:00:00 AM | 19554 | 3.5% |
| 4/20/2023 12:00:00 AM | 19551 | 3.5% |
| 4/27/2023 12:00:00 AM | 19532 | 3.5% |
| 4/10/2023 12:00:00 AM | 19528 | 3.5% |
| 4/24/2023 12:00:00 AM | 19527 | 3.5% |
| Other values (20) | 365775 |
Length
| Value | Count | Frequency (%) |
| 12:00:00 | 561441 | |
| am | 561441 | |
| 4/14/2023 | 19636 | 1.2% |
| 4/7/2023 | 19591 | 1.2% |
| 4/21/2023 | 19585 | 1.2% |
| 4/13/2023 | 19585 | 1.2% |
| 4/28/2023 | 19577 | 1.2% |
| 4/6/2023 | 19554 | 1.2% |
| 4/20/2023 | 19551 | 1.2% |
| 4/27/2023 | 19532 | 1.2% |
| Other values (22) | 404830 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2865298 | |
| 2 | 1925775 | |
| / | 1122882 | 9.7% |
| 1122882 | 9.7% | |
| : | 1122882 | 9.7% |
| 1 | 804740 | 6.9% |
| 3 | 638513 | 5.5% |
| 4 | 618835 | 5.3% |
| A | 561441 | 4.8% |
| M | 561441 | 4.8% |
| Other values (5) | 278498 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11623187 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2865298 | |
| 2 | 1925775 | |
| / | 1122882 | 9.7% |
| 1122882 | 9.7% | |
| : | 1122882 | 9.7% |
| 1 | 804740 | 6.9% |
| 3 | 638513 | 5.5% |
| 4 | 618835 | 5.3% |
| A | 561441 | 4.8% |
| M | 561441 | 4.8% |
| Other values (5) | 278498 | 2.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11623187 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2865298 | |
| 2 | 1925775 | |
| / | 1122882 | 9.7% |
| 1122882 | 9.7% | |
| : | 1122882 | 9.7% |
| 1 | 804740 | 6.9% |
| 3 | 638513 | 5.5% |
| 4 | 618835 | 5.3% |
| A | 561441 | 4.8% |
| M | 561441 | 4.8% |
| Other values (5) | 278498 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11623187 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2865298 | |
| 2 | 1925775 | |
| / | 1122882 | 9.7% |
| 1122882 | 9.7% | |
| : | 1122882 | 9.7% |
| 1 | 804740 | 6.9% |
| 3 | 638513 | 5.5% |
| 4 | 618835 | 5.3% |
| A | 561441 | 4.8% |
| M | 561441 | 4.8% |
| Other values (5) | 278498 | 2.4% |
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1122882 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 115946 | |
| DL | 80230 | |
| AA | 77039 | |
| UA | 57791 | |
| OO | 56048 | |
| YX | 27104 | 4.8% |
| B6 | 24285 | 4.3% |
| NK | 22751 | 4.1% |
| AS | 19573 | 3.5% |
| MQ | 18137 | 3.2% |
| Other values (5) | 62537 |
Length
| Value | Count | Frequency (%) |
| wn | 115946 | |
| dl | 80230 | |
| aa | 77039 | |
| ua | 57791 | |
| oo | 56048 | |
| yx | 27104 | 4.8% |
| b6 | 24285 | 4.3% |
| nk | 22751 | 4.1% |
| as | 19573 | 3.5% |
| mq | 18137 | 3.2% |
| Other values (5) | 62537 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 238110 | |
| N | 138697 | |
| O | 128129 | |
| W | 115946 | |
| D | 80230 | 7.1% |
| L | 80230 | 7.1% |
| U | 57791 | 5.1% |
| 9 | 29344 | 2.6% |
| Y | 27104 | 2.4% |
| X | 27104 | 2.4% |
| Other values (11) | 200197 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1122882 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 238110 | |
| N | 138697 | |
| O | 128129 | |
| W | 115946 | |
| D | 80230 | 7.1% |
| L | 80230 | 7.1% |
| U | 57791 | 5.1% |
| 9 | 29344 | 2.6% |
| Y | 27104 | 2.4% |
| X | 27104 | 2.4% |
| Other values (11) | 200197 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1122882 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 238110 | |
| N | 138697 | |
| O | 128129 | |
| W | 115946 | |
| D | 80230 | 7.1% |
| L | 80230 | 7.1% |
| U | 57791 | 5.1% |
| 9 | 29344 | 2.6% |
| Y | 27104 | 2.4% |
| X | 27104 | 2.4% |
| Other values (11) | 200197 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1122882 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 238110 | |
| N | 138697 | |
| O | 128129 | |
| W | 115946 | |
| D | 80230 | 7.1% |
| L | 80230 | 7.1% |
| U | 57791 | 5.1% |
| 9 | 29344 | 2.6% |
| Y | 27104 | 2.4% |
| X | 27104 | 2.4% |
| Other values (11) | 200197 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5906 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2278.7027 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 278 |
| Q1 | 1046 |
| median | 2039 |
| Q3 | 3312 |
| 95-th percentile | 5343 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2266 |
Descriptive statistics
| Standard deviation | 1550.8626 |
|---|---|
| Coefficient of variation (CV) | 0.68059016 |
| Kurtosis | -0.53211783 |
| Mean | 2278.7027 |
| Median Absolute Deviation (MAD) | 1067 |
| Skewness | 0.62642928 |
| Sum | 1.2793571 × 109 |
| Variance | 2405174.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 533 | 330 | 0.1% |
| 777 | 307 | 0.1% |
| 2086 | 306 | 0.1% |
| 538 | 305 | 0.1% |
| 2010 | 301 | 0.1% |
| 360 | 284 | 0.1% |
| 321 | 282 | 0.1% |
| 1191 | 279 | < 0.1% |
| 374 | 273 | < 0.1% |
| 555 | 273 | < 0.1% |
| Other values (5896) | 558501 |
| Value | Count | Frequency (%) |
| 1 | 142 | |
| 2 | 179 | |
| 3 | 145 | |
| 4 | 176 | |
| 5 | 63 | < 0.1% |
| 6 | 70 | < 0.1% |
| 7 | 82 | |
| 8 | 71 | < 0.1% |
| 9 | 133 | |
| 10 | 201 |
| Value | Count | Frequency (%) |
| 8819 | 1 | < 0.1% |
| 8805 | 1 | < 0.1% |
| 8800 | 2 | |
| 8799 | 2 | |
| 8789 | 1 | < 0.1% |
| 8788 | 1 | < 0.1% |
| 8783 | 3 | |
| 8775 | 1 | < 0.1% |
| 8773 | 2 | |
| 8772 | 2 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12654.165 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1527.4141 |
|---|---|
| Coefficient of variation (CV) | 0.12070446 |
| Kurtosis | -1.2973354 |
| Mean | 12654.165 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10124518 |
| Sum | 7.104567 × 109 |
| Variance | 2332994 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 27535 | 4.9% |
| 11298 | 22870 | 4.1% |
| 11292 | 22735 | 4.0% |
| 13930 | 21185 | 3.8% |
| 12889 | 15802 | 2.8% |
| 11057 | 15674 | 2.8% |
| 12892 | 15660 | 2.8% |
| 14107 | 14928 | 2.7% |
| 13204 | 14085 | 2.5% |
| 12953 | 13816 | 2.5% |
| Other values (330) | 377151 |
| Value | Count | Frequency (%) |
| 10135 | 350 | 0.1% |
| 10136 | 88 | < 0.1% |
| 10140 | 1864 | |
| 10141 | 60 | < 0.1% |
| 10146 | 85 | < 0.1% |
| 10155 | 88 | < 0.1% |
| 10157 | 120 | < 0.1% |
| 10158 | 291 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 60 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 139 | < 0.1% |
| 16218 | 120 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 910 | |
| 15841 | 60 | < 0.1% |
| 15624 | 793 | |
| 15607 | 87 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
| 15412 | 1050 |
ORIGIN
Text
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1684323 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ROC |
|---|---|
| 2nd row | ITH |
| 3rd row | JFK |
| 4th row | CLE |
| 5th row | JFK |
| Value | Count | Frequency (%) |
| atl | 27535 | 4.9% |
| dfw | 22870 | 4.1% |
| den | 22735 | 4.0% |
| ord | 21185 | 3.8% |
| las | 15802 | 2.8% |
| clt | 15674 | 2.8% |
| lax | 15660 | 2.8% |
| phx | 14928 | 2.7% |
| mco | 14085 | 2.5% |
| lga | 13816 | 2.5% |
| Other values (330) | 377151 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 190484 | 11.3% |
| L | 155987 | 9.3% |
| S | 144072 | 8.6% |
| D | 130500 | 7.7% |
| T | 88769 | 5.3% |
| O | 86674 | 5.1% |
| C | 84435 | 5.0% |
| M | 75147 | 4.5% |
| F | 70282 | 4.2% |
| P | 66530 | 3.9% |
| Other values (16) | 591443 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 190484 | 11.3% |
| L | 155987 | 9.3% |
| S | 144072 | 8.6% |
| D | 130500 | 7.7% |
| T | 88769 | 5.3% |
| O | 86674 | 5.1% |
| C | 84435 | 5.0% |
| M | 75147 | 4.5% |
| F | 70282 | 4.2% |
| P | 66530 | 3.9% |
| Other values (16) | 591443 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 190484 | 11.3% |
| L | 155987 | 9.3% |
| S | 144072 | 8.6% |
| D | 130500 | 7.7% |
| T | 88769 | 5.3% |
| O | 86674 | 5.1% |
| C | 84435 | 5.0% |
| M | 75147 | 4.5% |
| F | 70282 | 4.2% |
| P | 66530 | 3.9% |
| Other values (16) | 591443 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 190484 | 11.3% |
| L | 155987 | 9.3% |
| S | 144072 | 8.6% |
| D | 130500 | 7.7% |
| T | 88769 | 5.3% |
| O | 86674 | 5.1% |
| C | 84435 | 5.0% |
| M | 75147 | 4.5% |
| F | 70282 | 4.2% |
| P | 66530 | 3.9% |
| Other values (16) | 591443 |
ORIGIN_CITY_NAME
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.06017 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7332515 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Rochester, NY |
|---|---|
| 2nd row | Ithaca/Cortland, NY |
| 3rd row | New York, NY |
| 4th row | Cleveland, OH |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 59719 | 4.6% |
| tx | 57175 | 4.4% |
| fl | 53897 | 4.1% |
| ny | 32235 | 2.5% |
| ga | 29883 | 2.3% |
| new | 29797 | 2.3% |
| il | 29179 | 2.2% |
| san | 28397 | 2.2% |
| chicago | 28014 | 2.1% |
| atlanta | 27535 | 2.1% |
| Other values (406) | 935530 |
Most occurring characters
| Value | Count | Frequency (%) |
| 749920 | 10.2% | |
| a | 561828 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387093 | 5.3% |
| n | 356877 | 4.9% |
| t | 348529 | 4.8% |
| l | 320764 | 4.4% |
| i | 276083 | 3.8% |
| r | 268802 | 3.7% |
| Other values (46) | 3097698 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7332515 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 749920 | 10.2% | |
| a | 561828 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387093 | 5.3% |
| n | 356877 | 4.9% |
| t | 348529 | 4.8% |
| l | 320764 | 4.4% |
| i | 276083 | 3.8% |
| r | 268802 | 3.7% |
| Other values (46) | 3097698 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7332515 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 749920 | 10.2% | |
| a | 561828 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387093 | 5.3% |
| n | 356877 | 4.9% |
| t | 348529 | 4.8% |
| l | 320764 | 4.4% |
| i | 276083 | 3.8% |
| r | 268802 | 3.7% |
| Other values (46) | 3097698 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7332515 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 749920 | 10.2% | |
| a | 561828 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387093 | 5.3% |
| n | 356877 | 4.9% |
| t | 348529 | 4.8% |
| l | 320764 | 4.4% |
| i | 276083 | 3.8% |
| r | 268802 | 3.7% |
| Other values (46) | 3097698 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1584049 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4580463 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | New York |
| 3rd row | New York |
| 4th row | Ohio |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 59719 | 9.3% |
| texas | 57175 | 8.9% |
| florida | 53897 | 8.4% |
| new | 47455 | 7.4% |
| york | 32235 | 5.0% |
| georgia | 29883 | 4.6% |
| illinois | 29179 | 4.5% |
| carolina | 28055 | 4.3% |
| colorado | 24955 | 3.9% |
| north | 24262 | 3.8% |
| Other values (51) | 258488 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 612807 | |
| i | 515529 | 11.3% |
| o | 437458 | 9.6% |
| r | 335047 | 7.3% |
| n | 333993 | 7.3% |
| e | 282120 | 6.2% |
| s | 258906 | 5.7% |
| l | 254971 | 5.6% |
| C | 114686 | 2.5% |
| d | 114164 | 2.5% |
| Other values (37) | 1320782 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4580463 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 612807 | |
| i | 515529 | 11.3% |
| o | 437458 | 9.6% |
| r | 335047 | 7.3% |
| n | 333993 | 7.3% |
| e | 282120 | 6.2% |
| s | 258906 | 5.7% |
| l | 254971 | 5.6% |
| C | 114686 | 2.5% |
| d | 114164 | 2.5% |
| Other values (37) | 1320782 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4580463 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 612807 | |
| i | 515529 | 11.3% |
| o | 437458 | 9.6% |
| r | 335047 | 7.3% |
| n | 333993 | 7.3% |
| e | 282120 | 6.2% |
| s | 258906 | 5.7% |
| l | 254971 | 5.6% |
| C | 114686 | 2.5% |
| d | 114164 | 2.5% |
| Other values (37) | 1320782 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4580463 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 612807 | |
| i | 515529 | 11.3% |
| o | 437458 | 9.6% |
| r | 335047 | 7.3% |
| n | 333993 | 7.3% |
| e | 282120 | 6.2% |
| s | 258906 | 5.7% |
| l | 254971 | 5.6% |
| C | 114686 | 2.5% |
| d | 114164 | 2.5% |
| Other values (37) | 1320782 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.029919 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 81 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.784386 |
|---|---|
| Coefficient of variation (CV) | 0.49573247 |
| Kurtosis | -1.3258284 |
| Mean | 54.029919 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.0077426799 |
| Sum | 30334612 |
| Variance | 717.40331 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 59719 | 10.6% |
| 74 | 57175 | 10.2% |
| 33 | 53897 | 9.6% |
| 22 | 32235 | 5.7% |
| 34 | 29883 | 5.3% |
| 41 | 29179 | 5.2% |
| 82 | 24955 | 4.4% |
| 36 | 22859 | 4.1% |
| 38 | 19351 | 3.4% |
| 85 | 17332 | 3.1% |
| Other values (42) | 214856 |
| Value | Count | Frequency (%) |
| 1 | 2666 | 0.5% |
| 2 | 10977 | |
| 3 | 2776 | 0.5% |
| 4 | 533 | 0.1% |
| 5 | 98 | < 0.1% |
| 11 | 1957 | 0.3% |
| 12 | 1133 | 0.2% |
| 13 | 12214 | |
| 14 | 588 | 0.1% |
| 15 | 1335 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 14912 | 2.7% |
| 92 | 6261 | 1.1% |
| 91 | 59719 | |
| 88 | 624 | 0.1% |
| 87 | 9353 | 1.7% |
| 86 | 2123 | 0.4% |
| 85 | 17332 | 3.1% |
| 84 | 1772 | 0.3% |
| 83 | 2253 | 0.4% |
| 82 | 24955 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12654.137 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1527.4225 |
|---|---|
| Coefficient of variation (CV) | 0.12070538 |
| Kurtosis | -1.2972653 |
| Mean | 12654.137 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10121465 |
| Sum | 7.1045514 × 109 |
| Variance | 2333019.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 27543 | 4.9% |
| 11298 | 22856 | 4.1% |
| 11292 | 22733 | 4.0% |
| 13930 | 21185 | 3.8% |
| 12889 | 15802 | 2.8% |
| 11057 | 15672 | 2.8% |
| 12892 | 15666 | 2.8% |
| 14107 | 14925 | 2.7% |
| 13204 | 14083 | 2.5% |
| 12953 | 13819 | 2.5% |
| Other values (330) | 377157 |
| Value | Count | Frequency (%) |
| 10135 | 350 | 0.1% |
| 10136 | 88 | < 0.1% |
| 10140 | 1869 | |
| 10141 | 60 | < 0.1% |
| 10146 | 85 | < 0.1% |
| 10155 | 88 | < 0.1% |
| 10157 | 120 | < 0.1% |
| 10158 | 292 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 60 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 140 | < 0.1% |
| 16218 | 120 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 908 | |
| 15841 | 60 | < 0.1% |
| 15624 | 793 | |
| 15607 | 87 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
| 15412 | 1050 |
DEST
Text
| Distinct | 340 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1684323 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | JFK |
| 3rd row | ITH |
| 4th row | JFK |
| 5th row | CLE |
| Value | Count | Frequency (%) |
| atl | 27543 | 4.9% |
| dfw | 22856 | 4.1% |
| den | 22733 | 4.0% |
| ord | 21185 | 3.8% |
| las | 15802 | 2.8% |
| clt | 15672 | 2.8% |
| lax | 15666 | 2.8% |
| phx | 14925 | 2.7% |
| mco | 14083 | 2.5% |
| lga | 13819 | 2.5% |
| Other values (330) | 377157 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 190503 | 11.3% |
| L | 155995 | 9.3% |
| S | 144073 | 8.6% |
| D | 130497 | 7.7% |
| T | 88775 | 5.3% |
| O | 86673 | 5.1% |
| C | 84436 | 5.0% |
| M | 75158 | 4.5% |
| F | 70274 | 4.2% |
| P | 66528 | 3.9% |
| Other values (16) | 591411 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 190503 | 11.3% |
| L | 155995 | 9.3% |
| S | 144073 | 8.6% |
| D | 130497 | 7.7% |
| T | 88775 | 5.3% |
| O | 86673 | 5.1% |
| C | 84436 | 5.0% |
| M | 75158 | 4.5% |
| F | 70274 | 4.2% |
| P | 66528 | 3.9% |
| Other values (16) | 591411 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 190503 | 11.3% |
| L | 155995 | 9.3% |
| S | 144073 | 8.6% |
| D | 130497 | 7.7% |
| T | 88775 | 5.3% |
| O | 86673 | 5.1% |
| C | 84436 | 5.0% |
| M | 75158 | 4.5% |
| F | 70274 | 4.2% |
| P | 66528 | 3.9% |
| Other values (16) | 591411 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 190503 | 11.3% |
| L | 155995 | 9.3% |
| S | 144073 | 8.6% |
| D | 130497 | 7.7% |
| T | 88775 | 5.3% |
| O | 86673 | 5.1% |
| C | 84436 | 5.0% |
| M | 75158 | 4.5% |
| F | 70274 | 4.2% |
| P | 66528 | 3.9% |
| Other values (16) | 591411 |
DEST_CITY_NAME
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.060329 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7332604 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Ithaca/Cortland, NY |
| 4th row | New York, NY |
| 5th row | Cleveland, OH |
| Value | Count | Frequency (%) |
| ca | 59729 | 4.6% |
| tx | 57168 | 4.4% |
| fl | 53882 | 4.1% |
| ny | 32237 | 2.5% |
| ga | 29891 | 2.3% |
| new | 29806 | 2.3% |
| il | 29180 | 2.2% |
| san | 28394 | 2.2% |
| chicago | 28015 | 2.1% |
| atlanta | 27543 | 2.1% |
| Other values (406) | 935517 |
Most occurring characters
| Value | Count | Frequency (%) |
| 749921 | 10.2% | |
| a | 561840 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387111 | 5.3% |
| n | 356910 | 4.9% |
| t | 348511 | 4.8% |
| l | 320763 | 4.4% |
| i | 276074 | 3.8% |
| r | 268800 | 3.7% |
| Other values (46) | 3097753 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7332604 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 749921 | 10.2% | |
| a | 561840 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387111 | 5.3% |
| n | 356910 | 4.9% |
| t | 348511 | 4.8% |
| l | 320763 | 4.4% |
| i | 276074 | 3.8% |
| r | 268800 | 3.7% |
| Other values (46) | 3097753 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7332604 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 749921 | 10.2% | |
| a | 561840 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387111 | 5.3% |
| n | 356910 | 4.9% |
| t | 348511 | 4.8% |
| l | 320763 | 4.4% |
| i | 276074 | 3.8% |
| r | 268800 | 3.7% |
| Other values (46) | 3097753 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7332604 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 749921 | 10.2% | |
| a | 561840 | 7.7% |
| , | 561441 | 7.7% |
| o | 403480 | 5.5% |
| e | 387111 | 5.3% |
| n | 356910 | 4.9% |
| t | 348511 | 4.8% |
| l | 320763 | 4.4% |
| i | 276074 | 3.8% |
| r | 268800 | 3.7% |
| Other values (46) | 3097753 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1585545 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4580547 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | New York |
| 3rd row | New York |
| 4th row | New York |
| 5th row | Ohio |
| Value | Count | Frequency (%) |
| california | 59729 | 9.3% |
| texas | 57168 | 8.9% |
| florida | 53882 | 8.3% |
| new | 47462 | 7.4% |
| york | 32237 | 5.0% |
| georgia | 29891 | 4.6% |
| illinois | 29180 | 4.5% |
| carolina | 28061 | 4.3% |
| colorado | 24950 | 3.9% |
| north | 24266 | 3.8% |
| Other values (51) | 258490 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 612828 | |
| i | 515550 | 11.3% |
| o | 437466 | 9.6% |
| r | 335052 | 7.3% |
| n | 333990 | 7.3% |
| e | 282133 | 6.2% |
| s | 258908 | 5.7% |
| l | 254966 | 5.6% |
| C | 114698 | 2.5% |
| d | 114147 | 2.5% |
| Other values (37) | 1320809 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4580547 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 612828 | |
| i | 515550 | 11.3% |
| o | 437466 | 9.6% |
| r | 335052 | 7.3% |
| n | 333990 | 7.3% |
| e | 282133 | 6.2% |
| s | 258908 | 5.7% |
| l | 254966 | 5.6% |
| C | 114698 | 2.5% |
| d | 114147 | 2.5% |
| Other values (37) | 1320809 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4580547 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 612828 | |
| i | 515550 | 11.3% |
| o | 437466 | 9.6% |
| r | 335052 | 7.3% |
| n | 333990 | 7.3% |
| e | 282133 | 6.2% |
| s | 258908 | 5.7% |
| l | 254966 | 5.6% |
| C | 114698 | 2.5% |
| d | 114147 | 2.5% |
| Other values (37) | 1320809 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4580547 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 612828 | |
| i | 515550 | 11.3% |
| o | 437466 | 9.6% |
| r | 335052 | 7.3% |
| n | 333990 | 7.3% |
| e | 282133 | 6.2% |
| s | 258908 | 5.7% |
| l | 254966 | 5.6% |
| C | 114698 | 2.5% |
| d | 114147 | 2.5% |
| Other values (37) | 1320809 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.030856 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 81 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.784294 |
|---|---|
| Coefficient of variation (CV) | 0.49572217 |
| Kurtosis | -1.3258143 |
| Mean | 54.030856 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.0077027066 |
| Sum | 30335138 |
| Variance | 717.39838 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 59729 | 10.6% |
| 74 | 57168 | 10.2% |
| 33 | 53882 | 9.6% |
| 22 | 32237 | 5.7% |
| 34 | 29891 | 5.3% |
| 41 | 29180 | 5.2% |
| 82 | 24950 | 4.4% |
| 36 | 22861 | 4.1% |
| 38 | 19351 | 3.4% |
| 85 | 17332 | 3.1% |
| Other values (42) | 214860 |
| Value | Count | Frequency (%) |
| 1 | 2667 | 0.5% |
| 2 | 10977 | |
| 3 | 2771 | 0.5% |
| 4 | 534 | 0.1% |
| 5 | 98 | < 0.1% |
| 11 | 1958 | 0.3% |
| 12 | 1135 | 0.2% |
| 13 | 12214 | |
| 14 | 589 | 0.1% |
| 15 | 1336 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 14910 | 2.7% |
| 92 | 6264 | 1.1% |
| 91 | 59729 | |
| 88 | 623 | 0.1% |
| 87 | 9350 | 1.7% |
| 86 | 2128 | 0.4% |
| 85 | 17332 | 3.1% |
| 84 | 1772 | 0.3% |
| 83 | 2251 | 0.4% |
| 82 | 24950 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1202 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1334.9524 |
| Minimum | 3 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 908 |
| median | 1325 |
| Q3 | 1745 |
| 95-th percentile | 2135 |
| Maximum | 2359 |
| Range | 2356 |
| Interquartile range (IQR) | 837 |
Descriptive statistics
| Standard deviation | 499.16463 |
|---|---|
| Coefficient of variation (CV) | 0.37391941 |
| Kurtosis | -1.0880355 |
| Mean | 1334.9524 |
| Median Absolute Deviation (MAD) | 420 |
| Skewness | 0.079931655 |
| Sum | 7.4949703 × 108 |
| Variance | 249165.33 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 12315 | 2.2% |
| 700 | 8818 | 1.6% |
| 800 | 5486 | 1.0% |
| 900 | 3597 | 0.6% |
| 630 | 3399 | 0.6% |
| 830 | 3285 | 0.6% |
| 1000 | 3152 | 0.6% |
| 615 | 3102 | 0.6% |
| 730 | 3069 | 0.5% |
| 1100 | 2953 | 0.5% |
| Other values (1192) | 512265 |
| Value | Count | Frequency (%) |
| 3 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 13 | |
| 6 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 10 | |
| 11 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 13 |
| Value | Count | Frequency (%) |
| 2359 | 865 | |
| 2358 | 1 | < 0.1% |
| 2357 | 59 | < 0.1% |
| 2356 | 26 | < 0.1% |
| 2355 | 215 | < 0.1% |
| 2354 | 61 | < 0.1% |
| 2353 | 58 | < 0.1% |
| 2351 | 1 | < 0.1% |
| 2350 | 120 | < 0.1% |
| 2349 | 56 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING 
| Distinct | 1408 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 9310 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1338.5263 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 557 |
| Q1 | 909 |
| median | 1328 |
| Q3 | 1754 |
| 95-th percentile | 2153 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 845 |
Descriptive statistics
| Standard deviation | 516.31454 |
|---|---|
| Coefficient of variation (CV) | 0.38573357 |
| Kurtosis | -1.0017798 |
| Mean | 1338.5263 |
| Median Absolute Deviation (MAD) | 423 |
| Skewness | 0.028552518 |
| Sum | 7.3904188 × 108 |
| Variance | 266580.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 555 | 1535 | 0.3% |
| 556 | 1359 | 0.2% |
| 557 | 1348 | 0.2% |
| 554 | 1302 | 0.2% |
| 559 | 1211 | 0.2% |
| 558 | 1209 | 0.2% |
| 655 | 1151 | 0.2% |
| 553 | 1101 | 0.2% |
| 600 | 1094 | 0.2% |
| 654 | 1039 | 0.2% |
| Other values (1398) | 539782 | |
| (Missing) | 9310 | 1.7% |
| Value | Count | Frequency (%) |
| 1 | 88 | |
| 2 | 78 | |
| 3 | 61 | |
| 4 | 61 | |
| 5 | 71 | |
| 6 | 61 | |
| 7 | 52 | |
| 8 | 61 | |
| 9 | 65 | |
| 10 | 33 | < 0.1% |
| Value | Count | Frequency (%) |
| 2400 | 65 | |
| 2359 | 98 | |
| 2358 | 91 | |
| 2357 | 115 | |
| 2356 | 108 | |
| 2355 | 120 | |
| 2354 | 98 | |
| 2353 | 125 | |
| 2352 | 124 | |
| 2351 | 110 |
DEP_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1130 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 9311 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.723784 |
| Minimum | -68 |
|---|---|
| Maximum | 2935 |
| Zeros | 25076 |
| Zeros (%) | 4.5% |
| Negative | 305859 |
| Negative (%) | 54.5% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -68 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -5 |
| median | -2 |
| Q3 | 11 |
| 95-th percentile | 85 |
| Maximum | 2935 |
| Range | 3003 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 56.065508 |
|---|---|
| Coefficient of variation (CV) | 4.0852805 |
| Kurtosis | 220.67919 |
| Mean | 13.723784 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 11.047413 |
| Sum | 7577313 |
| Variance | 3143.3412 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 40116 | 7.1% |
| -4 | 37252 | 6.6% |
| -3 | 36220 | 6.5% |
| -2 | 33031 | 5.9% |
| -6 | 32152 | 5.7% |
| -1 | 29644 | 5.3% |
| -7 | 26682 | 4.8% |
| 0 | 25076 | 4.5% |
| -8 | 21487 | 3.8% |
| -9 | 15742 | 2.8% |
| Other values (1120) | 254728 |
| Value | Count | Frequency (%) |
| -68 | 1 | < 0.1% |
| -52 | 1 | < 0.1% |
| -47 | 2 | |
| -45 | 1 | < 0.1% |
| -43 | 1 | < 0.1% |
| -40 | 3 | |
| -37 | 1 | < 0.1% |
| -36 | 2 | |
| -35 | 4 | |
| -34 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2935 | 1 | |
| 2668 | 1 | |
| 2665 | 1 | |
| 2383 | 1 | |
| 2327 | 1 | |
| 2281 | 1 | |
| 2275 | 1 | |
| 1865 | 1 | |
| 1850 | 1 | |
| 1793 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING 
| Distinct | 164 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9528 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.275572 |
| Minimum | 1 |
|---|---|
| Maximum | 196 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 33 |
| Maximum | 196 |
| Range | 195 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 9.2430334 |
|---|---|
| Coefficient of variation (CV) | 0.53503486 |
| Kurtosis | 24.22288 |
| Mean | 17.275572 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.5153901 |
| Sum | 9534613 |
| Variance | 85.433666 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 45075 | 8.0% |
| 13 | 44920 | 8.0% |
| 11 | 42334 | 7.5% |
| 14 | 42058 | 7.5% |
| 15 | 38205 | 6.8% |
| 10 | 34416 | 6.1% |
| 16 | 33611 | 6.0% |
| 17 | 29133 | 5.2% |
| 18 | 25464 | 4.5% |
| 9 | 24606 | 4.4% |
| Other values (154) | 192091 |
| Value | Count | Frequency (%) |
| 1 | 11 | < 0.1% |
| 2 | 20 | < 0.1% |
| 3 | 68 | < 0.1% |
| 4 | 222 | < 0.1% |
| 5 | 620 | 0.1% |
| 6 | 2339 | 0.4% |
| 7 | 6969 | 1.2% |
| 8 | 14440 | |
| 9 | 24606 | |
| 10 | 34416 |
| Value | Count | Frequency (%) |
| 196 | 1 | |
| 179 | 1 | |
| 172 | 1 | |
| 171 | 2 | |
| 166 | 1 | |
| 165 | 1 | |
| 163 | 1 | |
| 161 | 1 | |
| 160 | 2 | |
| 159 | 1 |
TAXI_IN
Real number (ℝ)
MISSING 
| Distinct | 147 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9769 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.9866243 |
| Minimum | 1 |
|---|---|
| Maximum | 194 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 18 |
| Maximum | 194 |
| Range | 193 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.3066904 |
|---|---|
| Coefficient of variation (CV) | 0.78965658 |
| Kurtosis | 46.043104 |
| Mean | 7.9866243 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.6103627 |
| Sum | 4405997 |
| Variance | 39.774344 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 82074 | |
| 5 | 78586 | |
| 6 | 65628 | |
| 7 | 53765 | |
| 3 | 49743 | |
| 8 | 41669 | |
| 9 | 32488 | 5.8% |
| 10 | 25641 | 4.6% |
| 11 | 19811 | 3.5% |
| 12 | 15668 | 2.8% |
| Other values (137) | 86599 |
| Value | Count | Frequency (%) |
| 1 | 777 | 0.1% |
| 2 | 12400 | 2.2% |
| 3 | 49743 | |
| 4 | 82074 | |
| 5 | 78586 | |
| 6 | 65628 | |
| 7 | 53765 | |
| 8 | 41669 | |
| 9 | 32488 | 5.8% |
| 10 | 25641 | 4.6% |
| Value | Count | Frequency (%) |
| 194 | 1 | |
| 178 | 1 | |
| 177 | 1 | |
| 176 | 1 | |
| 173 | 1 | |
| 169 | 1 | |
| 167 | 1 | |
| 166 | 2 | |
| 160 | 2 | |
| 157 | 1 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1305 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1487.1325 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 715 |
| Q1 | 1057 |
| median | 1515 |
| Q3 | 1929 |
| 95-th percentile | 2302 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 872 |
Descriptive statistics
| Standard deviation | 529.72473 |
|---|---|
| Coefficient of variation (CV) | 0.35620546 |
| Kurtosis | -0.49208117 |
| Mean | 1487.1325 |
| Median Absolute Deviation (MAD) | 415 |
| Skewness | -0.29452539 |
| Sum | 8.3493718 × 108 |
| Variance | 280608.29 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2359 | 3351 | 0.6% |
| 2100 | 1802 | 0.3% |
| 1810 | 1666 | 0.3% |
| 900 | 1632 | 0.3% |
| 2150 | 1610 | 0.3% |
| 2200 | 1609 | 0.3% |
| 1400 | 1608 | 0.3% |
| 1940 | 1600 | 0.3% |
| 950 | 1599 | 0.3% |
| 1915 | 1590 | 0.3% |
| Other values (1295) | 543374 |
| Value | Count | Frequency (%) |
| 1 | 51 | < 0.1% |
| 2 | 28 | < 0.1% |
| 3 | 54 | < 0.1% |
| 4 | 98 | < 0.1% |
| 5 | 760 | |
| 6 | 87 | < 0.1% |
| 7 | 78 | < 0.1% |
| 8 | 41 | < 0.1% |
| 9 | 103 | < 0.1% |
| 10 | 548 |
| Value | Count | Frequency (%) |
| 2359 | 3351 | |
| 2358 | 628 | 0.1% |
| 2357 | 828 | 0.1% |
| 2356 | 758 | 0.1% |
| 2355 | 1035 | 0.2% |
| 2354 | 463 | 0.1% |
| 2353 | 378 | 0.1% |
| 2352 | 387 | 0.1% |
| 2351 | 428 | 0.1% |
| 2350 | 971 | 0.2% |
ARR_TIME
Real number (ℝ)
MISSING 
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 9769 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1450.6796 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 608 |
| Q1 | 1035 |
| median | 1458 |
| Q3 | 1918 |
| 95-th percentile | 2256 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 883 |
Descriptive statistics
| Standard deviation | 559.38211 |
|---|---|
| Coefficient of variation (CV) | 0.38560004 |
| Kurtosis | -0.37467569 |
| Mean | 1450.6796 |
| Median Absolute Deviation (MAD) | 442 |
| Skewness | -0.39282352 |
| Sum | 8.002993 × 108 |
| Variance | 312908.34 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1847 | 642 | 0.1% |
| 2143 | 625 | 0.1% |
| 1634 | 620 | 0.1% |
| 1637 | 610 | 0.1% |
| 1152 | 606 | 0.1% |
| 1642 | 604 | 0.1% |
| 908 | 599 | 0.1% |
| 1841 | 599 | 0.1% |
| 1640 | 597 | 0.1% |
| 1621 | 597 | 0.1% |
| Other values (1430) | 545573 | |
| (Missing) | 9769 | 1.7% |
| Value | Count | Frequency (%) |
| 1 | 395 | |
| 2 | 340 | |
| 3 | 325 | |
| 4 | 332 | |
| 5 | 345 | |
| 6 | 315 | |
| 7 | 330 | |
| 8 | 287 | |
| 9 | 341 | |
| 10 | 306 |
| Value | Count | Frequency (%) |
| 2400 | 331 | |
| 2359 | 394 | |
| 2358 | 374 | |
| 2357 | 408 | |
| 2356 | 372 | |
| 2355 | 443 | |
| 2354 | 449 | |
| 2353 | 438 | |
| 2352 | 440 | |
| 2351 | 459 |
ARR_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1181 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 11192 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1129598 |
| Minimum | -94 |
|---|---|
| Maximum | 2916 |
| Zeros | 10477 |
| Zeros (%) | 1.9% |
| Negative | 320273 |
| Negative (%) | 57.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -94 |
|---|---|
| 5-th percentile | -26 |
| Q1 | -14 |
| median | -4 |
| Q3 | 12 |
| 95-th percentile | 86 |
| Maximum | 2916 |
| Range | 3010 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 58.170159 |
|---|---|
| Coefficient of variation (CV) | 6.3832345 |
| Kurtosis | 191.68988 |
| Mean | 9.1129598 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 10.021578 |
| Sum | 5014397 |
| Variance | 3383.7674 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -10 | 15345 | 2.7% |
| -9 | 15012 | 2.7% |
| -11 | 14963 | 2.7% |
| -8 | 14927 | 2.7% |
| -12 | 14901 | 2.7% |
| -7 | 14600 | 2.6% |
| -13 | 14295 | 2.5% |
| -6 | 14137 | 2.5% |
| -14 | 13886 | 2.5% |
| -5 | 13701 | 2.4% |
| Other values (1171) | 404482 |
| Value | Count | Frequency (%) |
| -94 | 1 | < 0.1% |
| -92 | 1 | < 0.1% |
| -89 | 1 | < 0.1% |
| -85 | 1 | < 0.1% |
| -84 | 1 | < 0.1% |
| -83 | 1 | < 0.1% |
| -81 | 2 | |
| -80 | 1 | < 0.1% |
| -79 | 2 | |
| -78 | 4 |
| Value | Count | Frequency (%) |
| 2916 | 1 | |
| 2656 | 1 | |
| 2655 | 1 | |
| 2382 | 1 | |
| 2314 | 1 | |
| 2270 | 1 | |
| 2258 | 1 | |
| 1864 | 1 | |
| 1847 | 1 | |
| 1797 | 1 |
CANCELLED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0.0 | |
|---|---|
| 1.0 | 9589 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1684323 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 551852 | |
| 1.0 | 9589 | 1.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 551852 | |
| 1.0 | 9589 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1113293 | |
| . | 561441 | |
| 1 | 9589 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1113293 | |
| . | 561441 | |
| 1 | 9589 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1113293 | |
| . | 561441 | |
| 1 | 9589 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1113293 | |
| . | 561441 | |
| 1 | 9589 | 0.6% |
CANCELLATION_CODE
Categorical
MISSING 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 551852 |
| Missing (%) | 98.3% |
| Memory size | 4.3 MiB |
| B | |
|---|---|
| A | |
| C | |
| D | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 9589 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| B | 5165 | 0.9% |
| A | 2962 | 0.5% |
| C | 1461 | 0.3% |
| D | 1 | < 0.1% |
| (Missing) | 551852 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 5165 | |
| a | 2962 | |
| c | 1461 | 15.2% |
| d | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 5165 | |
| A | 2962 | |
| C | 1461 | 15.2% |
| D | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9589 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 5165 | |
| A | 2962 | |
| C | 1461 | 15.2% |
| D | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9589 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 5165 | |
| A | 2962 | |
| C | 1461 | 15.2% |
| D | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9589 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 5165 | |
| A | 2962 | |
| C | 1461 | 15.2% |
| D | 1 | < 0.1% |
DIVERTED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1603 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1684323 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 559838 | |
| 1.0 | 1603 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 559838 | |
| 1.0 | 1603 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1121279 | |
| . | 561441 | |
| 1 | 1603 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1121279 | |
| . | 561441 | |
| 1 | 1603 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1121279 | |
| . | 561441 | |
| 1 | 1603 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1684323 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1121279 | |
| . | 561441 | |
| 1 | 1603 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING 
| Distinct | 623 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 11192 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.88136 |
| Minimum | 8 |
|---|---|
| Maximum | 686 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 63 |
| median | 98 |
| Q3 | 145 |
| 95-th percentile | 272 |
| Maximum | 686 |
| Range | 678 |
| Interquartile range (IQR) | 82 |
Descriptive statistics
| Standard deviation | 70.591469 |
|---|---|
| Coefficient of variation (CV) | 0.61447281 |
| Kurtosis | 2.5124361 |
| Mean | 114.88136 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 1.4161643 |
| Sum | 63213351 |
| Variance | 4983.1555 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 4642 | 0.8% |
| 64 | 4634 | 0.8% |
| 61 | 4607 | 0.8% |
| 58 | 4598 | 0.8% |
| 66 | 4595 | 0.8% |
| 65 | 4534 | 0.8% |
| 56 | 4508 | 0.8% |
| 57 | 4501 | 0.8% |
| 63 | 4443 | 0.8% |
| 54 | 4437 | 0.8% |
| Other values (613) | 504750 | |
| (Missing) | 11192 | 2.0% |
| Value | Count | Frequency (%) |
| 8 | 5 | < 0.1% |
| 9 | 18 | < 0.1% |
| 10 | 16 | < 0.1% |
| 11 | 5 | < 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 8 | < 0.1% |
| 14 | 9 | < 0.1% |
| 15 | 37 | < 0.1% |
| 16 | 91 | |
| 17 | 142 |
| Value | Count | Frequency (%) |
| 686 | 1 | < 0.1% |
| 673 | 1 | < 0.1% |
| 669 | 1 | < 0.1% |
| 666 | 1 | < 0.1% |
| 663 | 1 | < 0.1% |
| 658 | 1 | < 0.1% |
| 657 | 3 | |
| 654 | 1 | < 0.1% |
| 653 | 1 | < 0.1% |
| 651 | 1 | < 0.1% |
CARRIER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 892 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 435559 |
| Missing (%) | 77.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.981673 |
| Minimum | 0 |
|---|---|
| Maximum | 2916 |
| Zeros | 54172 |
| Zeros (%) | 9.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 22 |
| 95-th percentile | 97 |
| Maximum | 2916 |
| Range | 2916 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 73.423339 |
|---|---|
| Coefficient of variation (CV) | 3.0616437 |
| Kurtosis | 182.0958 |
| Mean | 23.981673 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 10.800042 |
| Sum | 3018861 |
| Variance | 5390.9867 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 54172 | 9.6% |
| 1 | 2382 | 0.4% |
| 3 | 2366 | 0.4% |
| 6 | 2334 | 0.4% |
| 2 | 2321 | 0.4% |
| 4 | 2230 | 0.4% |
| 7 | 2183 | 0.4% |
| 15 | 2154 | 0.4% |
| 5 | 2147 | 0.4% |
| 8 | 1975 | 0.4% |
| Other values (882) | 51618 | 9.2% |
| (Missing) | 435559 |
| Value | Count | Frequency (%) |
| 0 | 54172 | |
| 1 | 2382 | 0.4% |
| 2 | 2321 | 0.4% |
| 3 | 2366 | 0.4% |
| 4 | 2230 | 0.4% |
| 5 | 2147 | 0.4% |
| 6 | 2334 | 0.4% |
| 7 | 2183 | 0.4% |
| 8 | 1975 | 0.4% |
| 9 | 1963 | 0.3% |
| Value | Count | Frequency (%) |
| 2916 | 1 | |
| 2656 | 1 | |
| 2655 | 1 | |
| 2328 | 1 | |
| 1864 | 1 | |
| 1789 | 1 | |
| 1787 | 1 | |
| 1759 | 1 | |
| 1748 | 1 | |
| 1737 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 435 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 435559 |
| Missing (%) | 77.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5527716 |
| Minimum | 0 |
|---|---|
| Maximum | 1643 |
| Zeros | 119465 |
| Zeros (%) | 21.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 1643 |
| Range | 1643 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 31.089189 |
|---|---|
| Coefficient of variation (CV) | 8.7506859 |
| Kurtosis | 727.16363 |
| Mean | 3.5527716 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.399204 |
| Sum | 447230 |
| Variance | 966.53767 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 119465 | 21.3% |
| 7 | 137 | < 0.1% |
| 15 | 134 | < 0.1% |
| 6 | 128 | < 0.1% |
| 17 | 126 | < 0.1% |
| 2 | 124 | < 0.1% |
| 16 | 116 | < 0.1% |
| 18 | 116 | < 0.1% |
| 3 | 115 | < 0.1% |
| 1 | 112 | < 0.1% |
| Other values (425) | 5309 | 0.9% |
| (Missing) | 435559 |
| Value | Count | Frequency (%) |
| 0 | 119465 | |
| 1 | 112 | < 0.1% |
| 2 | 124 | < 0.1% |
| 3 | 115 | < 0.1% |
| 4 | 103 | < 0.1% |
| 5 | 110 | < 0.1% |
| 6 | 128 | < 0.1% |
| 7 | 137 | < 0.1% |
| 8 | 92 | < 0.1% |
| 9 | 98 | < 0.1% |
| Value | Count | Frequency (%) |
| 1643 | 1 | |
| 1609 | 1 | |
| 1503 | 1 | |
| 1446 | 1 | |
| 1361 | 1 | |
| 1337 | 1 | |
| 1270 | 1 | |
| 1256 | 1 | |
| 1204 | 1 | |
| 1188 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 452 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 435559 |
| Missing (%) | 77.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.751386 |
| Minimum | 0 |
|---|---|
| Maximum | 1660 |
| Zeros | 64125 |
| Zeros (%) | 11.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 16 |
| 95-th percentile | 58 |
| Maximum | 1660 |
| Range | 1660 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 36.254634 |
|---|---|
| Coefficient of variation (CV) | 2.6364349 |
| Kurtosis | 314.55699 |
| Mean | 13.751386 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.352336 |
| Sum | 1731052 |
| Variance | 1314.3985 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 64125 | 11.4% |
| 1 | 3407 | 0.6% |
| 2 | 2510 | 0.4% |
| 3 | 2344 | 0.4% |
| 15 | 2344 | 0.4% |
| 4 | 2196 | 0.4% |
| 16 | 2040 | 0.4% |
| 5 | 2032 | 0.4% |
| 6 | 1957 | 0.3% |
| 17 | 1902 | 0.3% |
| Other values (442) | 41025 | 7.3% |
| (Missing) | 435559 |
| Value | Count | Frequency (%) |
| 0 | 64125 | |
| 1 | 3407 | 0.6% |
| 2 | 2510 | 0.4% |
| 3 | 2344 | 0.4% |
| 4 | 2196 | 0.4% |
| 5 | 2032 | 0.4% |
| 6 | 1957 | 0.3% |
| 7 | 1781 | 0.3% |
| 8 | 1741 | 0.3% |
| 9 | 1566 | 0.3% |
| Value | Count | Frequency (%) |
| 1660 | 1 | |
| 1487 | 1 | |
| 1409 | 2 | |
| 1402 | 1 | |
| 1401 | 1 | |
| 1358 | 1 | |
| 1300 | 1 | |
| 1276 | 1 | |
| 1191 | 1 | |
| 1178 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 435559 |
| Missing (%) | 77.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14313405 |
| Minimum | 0 |
|---|---|
| Maximum | 368 |
| Zeros | 125147 |
| Zeros (%) | 22.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 368 |
| Range | 368 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.0125307 |
|---|---|
| Coefficient of variation (CV) | 21.046919 |
| Kurtosis | 4090.4577 |
| Mean | 0.14313405 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 50.383342 |
| Sum | 18018 |
| Variance | 9.0753411 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 125147 | 22.3% |
| 9 | 34 | < 0.1% |
| 16 | 33 | < 0.1% |
| 15 | 28 | < 0.1% |
| 17 | 27 | < 0.1% |
| 10 | 27 | < 0.1% |
| 6 | 27 | < 0.1% |
| 8 | 26 | < 0.1% |
| 18 | 23 | < 0.1% |
| 14 | 22 | < 0.1% |
| Other values (92) | 488 | 0.1% |
| (Missing) | 435559 |
| Value | Count | Frequency (%) |
| 0 | 125147 | |
| 1 | 10 | < 0.1% |
| 2 | 17 | < 0.1% |
| 3 | 21 | < 0.1% |
| 4 | 22 | < 0.1% |
| 5 | 20 | < 0.1% |
| 6 | 27 | < 0.1% |
| 7 | 19 | < 0.1% |
| 8 | 26 | < 0.1% |
| 9 | 34 | < 0.1% |
| Value | Count | Frequency (%) |
| 368 | 1 | |
| 332 | 1 | |
| 228 | 1 | |
| 191 | 1 | |
| 190 | 1 | |
| 184 | 1 | |
| 152 | 1 | |
| 149 | 1 | |
| 136 | 2 | |
| 135 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 642 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 435559 |
| Missing (%) | 77.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.631504 |
| Minimum | 0 |
|---|---|
| Maximum | 2258 |
| Zeros | 59767 |
| Zeros (%) | 10.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 33 |
| 95-th percentile | 121 |
| Maximum | 2258 |
| Range | 2258 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 58.881248 |
|---|---|
| Coefficient of variation (CV) | 2.1309462 |
| Kurtosis | 120.76667 |
| Mean | 27.631504 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 7.4997916 |
| Sum | 3478309 |
| Variance | 3467.0014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 59767 | 10.6% |
| 15 | 1611 | 0.3% |
| 16 | 1469 | 0.3% |
| 17 | 1408 | 0.3% |
| 19 | 1378 | 0.2% |
| 18 | 1374 | 0.2% |
| 21 | 1275 | 0.2% |
| 20 | 1252 | 0.2% |
| 14 | 1202 | 0.2% |
| 13 | 1190 | 0.2% |
| Other values (632) | 53956 | 9.6% |
| (Missing) | 435559 |
| Value | Count | Frequency (%) |
| 0 | 59767 | |
| 1 | 819 | 0.1% |
| 2 | 907 | 0.2% |
| 3 | 905 | 0.2% |
| 4 | 865 | 0.2% |
| 5 | 917 | 0.2% |
| 6 | 984 | 0.2% |
| 7 | 986 | 0.2% |
| 8 | 1069 | 0.2% |
| 9 | 1047 | 0.2% |
| Value | Count | Frequency (%) |
| 2258 | 1 | |
| 2216 | 1 | |
| 1905 | 1 | |
| 1553 | 1 | |
| 1522 | 1 | |
| 1507 | 1 | |
| 1407 | 1 | |
| 1401 | 1 | |
| 1332 | 1 | |
| 1298 | 1 |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 4/3/2023 12:00:00 AM | 9E | 4628 | 14576 | ROC | Rochester, NY | New York | 22 | 12953 | LGA | New York, NY | New York | 22 | 937 | 932.0 | -5.0 | 7.0 | 5.0 | 1059 | 1031.0 | -28.0 | 0.0 | NaN | 0.0 | 47.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 4/3/2023 12:00:00 AM | 9E | 4629 | 12397 | ITH | Ithaca/Cortland, NY | New York | 22 | 12478 | JFK | New York, NY | New York | 22 | 1443 | 1438.0 | -5.0 | 12.0 | 7.0 | 1609 | 1540.0 | -29.0 | 0.0 | NaN | 0.0 | 43.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 4/3/2023 12:00:00 AM | 9E | 4629 | 12478 | JFK | New York, NY | New York | 22 | 12397 | ITH | Ithaca/Cortland, NY | New York | 22 | 1250 | 1249.0 | -1.0 | 25.0 | 2.0 | 1358 | 1400.0 | 2.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 4/3/2023 12:00:00 AM | 9E | 4630 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 12478 | JFK | New York, NY | New York | 22 | 1700 | 1656.0 | -4.0 | 26.0 | 9.0 | 1837 | 1838.0 | 1.0 | 0.0 | NaN | 0.0 | 67.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 4/3/2023 12:00:00 AM | 9E | 4632 | 12478 | JFK | New York, NY | New York | 22 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 1459 | 1455.0 | -4.0 | 25.0 | 7.0 | 1656 | 1646.0 | -10.0 | 0.0 | NaN | 0.0 | 79.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 4/3/2023 12:00:00 AM | 9E | 4633 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 12953 | LGA | New York, NY | New York | 22 | 1759 | 1754.0 | -5.0 | 11.0 | 4.0 | 1936 | 1924.0 | -12.0 | 0.0 | NaN | 0.0 | 75.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 4/3/2023 12:00:00 AM | 9E | 4634 | 12953 | LGA | New York, NY | New York | 22 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 1255 | 1251.0 | -4.0 | 28.0 | 8.0 | 1452 | 1440.0 | -12.0 | 0.0 | NaN | 0.0 | 73.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 4/3/2023 12:00:00 AM | 9E | 4635 | 10821 | BWI | Baltimore, MD | Maryland | 35 | 12478 | JFK | New York, NY | New York | 22 | 1715 | 1801.0 | 46.0 | 21.0 | 15.0 | 1837 | 1920.0 | 43.0 | 0.0 | NaN | 0.0 | 43.0 | 0.0 | 0.0 | 0.0 | 0.0 | 43.0 |
| 8 | 1 | 4/3/2023 12:00:00 AM | 9E | 4635 | 12478 | JFK | New York, NY | New York | 22 | 10821 | BWI | Baltimore, MD | Maryland | 35 | 1509 | 1543.0 | 34.0 | 56.0 | 5.0 | 1625 | 1722.0 | 57.0 | 0.0 | NaN | 0.0 | 38.0 | 0.0 | 0.0 | 23.0 | 0.0 | 34.0 |
| 9 | 1 | 4/3/2023 12:00:00 AM | 9E | 4638 | 12953 | LGA | New York, NY | New York | 22 | 13244 | MEM | Memphis, TN | Tennessee | 54 | 859 | 855.0 | -4.0 | 19.0 | 3.0 | 1109 | 1044.0 | -25.0 | 0.0 | NaN | 0.0 | 147.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 561431 | 7 | 4/30/2023 12:00:00 AM | YX | 5849 | 10821 | BWI | Baltimore, MD | Maryland | 35 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1956 | 2135.0 | 99.0 | 17.0 | 10.0 | 2131 | 2301.0 | 90.0 | 0.0 | NaN | 0.0 | 59.0 | 0.0 | 0.0 | 0.0 | 0.0 | 90.0 |
| 561432 | 7 | 4/30/2023 12:00:00 AM | YX | 5851 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 822 | 819.0 | -3.0 | 16.0 | 6.0 | 1110 | 1053.0 | -17.0 | 0.0 | NaN | 0.0 | 132.0 | NaN | NaN | NaN | NaN | NaN |
| 561433 | 7 | 4/30/2023 12:00:00 AM | YX | 5852 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 14100 | PHL | Philadelphia, PA | Pennsylvania | 23 | 1955 | 2111.0 | 76.0 | 15.0 | 4.0 | 2135 | 2239.0 | 64.0 | 0.0 | NaN | 0.0 | 69.0 | 0.0 | 0.0 | 0.0 | 0.0 | 64.0 |
| 561434 | 7 | 4/30/2023 12:00:00 AM | YX | 5853 | 12478 | JFK | New York, NY | New York | 22 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 600 | 553.0 | -7.0 | 33.0 | 17.0 | 715 | 717.0 | 2.0 | 0.0 | NaN | 0.0 | 34.0 | NaN | NaN | NaN | NaN | NaN |
| 561435 | 7 | 4/30/2023 12:00:00 AM | YX | 5854 | 12953 | LGA | New York, NY | New York | 22 | 10693 | BNA | Nashville, TN | Tennessee | 54 | 1029 | 1022.0 | -7.0 | 18.0 | 6.0 | 1217 | 1157.0 | -20.0 | 0.0 | NaN | 0.0 | 131.0 | NaN | NaN | NaN | NaN | NaN |
| 561436 | 7 | 4/30/2023 12:00:00 AM | YX | 5855 | 10821 | BWI | Baltimore, MD | Maryland | 35 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1215 | 1243.0 | 28.0 | 21.0 | 7.0 | 1346 | 1409.0 | 23.0 | 0.0 | NaN | 0.0 | 58.0 | 0.0 | 0.0 | 23.0 | 0.0 | 0.0 |
| 561437 | 7 | 4/30/2023 12:00:00 AM | YX | 5856 | 11278 | DCA | Washington, DC | Virginia | 38 | 12478 | JFK | New York, NY | New York | 22 | 1155 | 1222.0 | 27.0 | 40.0 | 8.0 | 1323 | 1354.0 | 31.0 | 0.0 | NaN | 0.0 | 44.0 | 0.0 | 0.0 | 31.0 | 0.0 | 0.0 |
| 561438 | 7 | 4/30/2023 12:00:00 AM | YX | 5857 | 14524 | RIC | Richmond, VA | Virginia | 38 | 12953 | LGA | New York, NY | New York | 22 | 845 | 937.0 | 52.0 | 10.0 | 4.0 | 1007 | 1043.0 | 36.0 | 0.0 | NaN | 0.0 | 52.0 | 0.0 | 0.0 | 36.0 | 0.0 | 0.0 |
| 561439 | 7 | 4/30/2023 12:00:00 AM | YX | 5858 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1220 | 1211.0 | -9.0 | 21.0 | 2.0 | 1404 | 1354.0 | -10.0 | 0.0 | NaN | 0.0 | 80.0 | NaN | NaN | NaN | NaN | NaN |
| 561440 | 7 | 4/30/2023 12:00:00 AM | YX | 5861 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1015 | 1009.0 | -6.0 | 13.0 | 7.0 | 1200 | 1142.0 | -18.0 | 0.0 | NaN | 0.0 | 73.0 | NaN | NaN | NaN | NaN | NaN |